Azure SQL PowerShell Reference
Module: Az.Sql
Overview
The Az.Sql module provides cmdlets to manage Azure SQL Database resources. You can use these cmdlets to create, configure, and manage SQL servers, databases, firewalls, and other related Azure SQL components.
Key Cmdlets
Get-AzSqlServer
Get-AzSqlServer -ResourceGroupName "MyResourceGroup"
Retrieves information about one or more Azure SQL servers.
Learn more →New-AzSqlServer
New-AzSqlServer -ResourceGroupName "MyResourceGroup" -Location "East US" -ServerName "mysqldbserver"
Creates a new Azure SQL server.
Learn more →Remove-AzSqlServer
Remove-AzSqlServer -ResourceGroupName "MyResourceGroup" -ServerName "mysqldbserver"
Deletes an Azure SQL server.
Learn more →Get-AzSqlDatabase
Get-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "mysqldbserver"
Retrieves information about one or more Azure SQL databases.
Learn more →New-AzSqlDatabase
New-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "mysqldbserver" -DatabaseName "myDatabase"
Creates a new Azure SQL database.
Learn more →Set-AzSqlDatabase
Set-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "mysqldbserver" -DatabaseName "myDatabase" -RequestedServiceObjectiveName "S0"
Updates an existing Azure SQL database's properties, such as performance tier.
Learn more →Get-AzSqlServerFirewallRule
Get-AzSqlServerFirewallRule -ResourceGroupName "MyResourceGroup" -ServerName "mysqldbserver"
Retrieves information about firewall rules for an Azure SQL server.
Learn more →New-AzSqlServerFirewallRule
New-AzSqlServerFirewallRule -ResourceGroupName "MyResourceGroup" -ServerName "mysqldbserver" -FirewallRuleName "AllowMyIP" -StartIpAddress "192.168.1.1" -EndIpAddress "192.168.1.1"
Creates a new firewall rule for an Azure SQL server.
Learn more →Get-AzSqlInstance
Get-AzSqlInstance -ResourceGroupName "MyResourceGroup"
Retrieves information about one or more Azure SQL Managed Instances.
Learn more →New-AzSqlInstance
New-AzSqlInstance -ResourceGroupName "MyResourceGroup" -Name "myinstance" -Location "East US" -SubnetId "/subscriptions/.../subnets/mysubnet"
Creates a new Azure SQL Managed Instance.
Learn more →